/*
Navicat SQL Server Data Transfer

Source Server         : LOCALHOST
Source Server Version : 110000
Source Host           : .:1433
Source Database       : AAACHAM2
Source Schema         : dbo

Target Server Type    : SQL Server
Target Server Version : 110000
File Encoding         : 65001

Date: 2014-04-29 17:38:02
*/


-- ----------------------------
-- Table structure for tb0083
-- ----------------------------
DROP TABLE [dbo].[tb0083]
GO
CREATE TABLE [dbo].[tb0083] (
[AssetID] varchar(20) NOT NULL ,
[DivisionID] varchar(20) NULL ,
[AssetName] nvarchar(150) NULL ,
[AssetStatus] tinyint NOT NULL DEFAULT ((0)) ,
[ConvertedAmount] money NULL ,
[AssetGroupID] varchar(20) NULL ,
[AssetAccountID] varchar(20) NULL ,
[DepAccountID] varchar(20) NULL ,
[Years] int NULL ,
[StartDate] datetime NULL ,
[EndDate] datetime NULL ,
[BeginMonth] int NULL ,
[BeginYear] int NULL ,
[ResidualValue] money NULL ,
[DepPeriods] int NULL ,
[MethodID] tinyint NOT NULL DEFAULT ((0)) ,
[Serial] varchar(50) NULL ,
[CountryID] varchar(20) NULL ,
[MadeYear] int NULL ,
[IsTangible] tinyint NULL ,
[DepartmentID] varchar(20) NULL ,
[EmployeeID] varchar(20) NULL ,
[SerialNo] varchar(20) NULL ,
[InvoiceNo] varchar(20) NULL ,
[InvoiceDate] datetime NULL ,
[SourceID1] varchar(20) NULL ,
[SourceAmount1] money NULL ,
[SourcePercent1] money NULL ,
[SourceID2] varchar(20) NULL ,
[SourceAmount2] money NULL ,
[SourcePercent2] money NULL ,
[SourceID3] varchar(20) NULL ,
[SourceAmount3] money NULL ,
[SourcePercent3] money NULL ,
[DebitDepAccountID1] varchar(20) NULL ,
[DepPercent1] money NULL ,
[DebitDepAccountID2] varchar(20) NULL ,
[DepPercent2] money NULL ,
[DebitDepAccountID3] varchar(20) NULL ,
[DepPercent3] money NULL ,
[DepPercent] money NULL ,
[DepAmount] money NULL ,
[Status] tinyint NULL ,
[CreateDate] datetime NULL ,
[CreateUserID] varchar(20) NULL ,
[LastModifyUserID] varchar(20) NULL ,
[LastModifyDate] datetime NULL ,
[EstablishDate] datetime NULL ,
[ParentAssetID] varchar(20) NULL ,
[Notes] nvarchar(250) NULL ,
[Ana01ID1] varchar(20) NULL ,
[Ana02ID1] varchar(20) NULL ,
[Ana03ID1] varchar(20) NULL ,
[Ana01ID2] varchar(20) NULL ,
[Ana02ID2] varchar(20) NULL ,
[Ana03ID2] varchar(20) NULL ,
[Ana01ID3] varchar(20) NULL ,
[Ana02ID3] varchar(20) NULL ,
[Ana03ID3] varchar(20) NULL ,
[Ana01ID4] varchar(20) NULL ,
[Ana02ID4] varchar(20) NULL ,
[Ana03ID4] varchar(20) NULL ,
[Ana01ID5] varchar(20) NULL ,
[Ana02ID5] varchar(20) NULL ,
[Ana03ID5] varchar(20) NULL ,
[DepPercent4] money NULL ,
[DepPercent5] money NULL ,
[DepPercent6] money NULL ,
[DebitDepAccountID5] varchar(20) NULL ,
[DebitDepAccountID6] varchar(20) NULL ,
[DebitDepAccountID4] varchar(20) NULL ,
[Ana01ID6] varchar(20) NULL ,
[Ana02ID6] varchar(20) NULL ,
[Ana03ID6] varchar(20) NULL ,
[DepMonths] int NULL ,
[S1] varchar(20) NULL ,
[S2] varchar(20) NULL ,
[S3] varchar(20) NULL ,
[Ana04ID1] varchar(20) NULL ,
[Ana04ID2] varchar(20) NULL ,
[Ana04ID3] varchar(20) NULL ,
[Ana04ID4] varchar(20) NULL ,
[Ana04ID5] varchar(20) NULL ,
[Ana04ID6] varchar(20) NULL ,
[Ana05ID1] varchar(20) NULL ,
[Ana05ID2] varchar(20) NULL ,
[Ana05ID3] varchar(20) NULL ,
[Ana05ID4] varchar(20) NULL ,
[Ana05ID5] varchar(20) NULL ,
[Ana05ID6] varchar(20) NULL ,
[CauseID] varchar(20) NULL 
)


GO

-- ----------------------------
-- Records of tb0083
-- ----------------------------

-- ----------------------------
-- Indexes structure for table tb0083
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table tb0083
-- ----------------------------
ALTER TABLE [dbo].[tb0083] ADD PRIMARY KEY NONCLUSTERED ([AssetID])
GO
